However, in some cases, you will need to read cursors both forward and backward, in which case you should use scrollable cursor.
但某些情况下,您需要游标既能向前又能向后,此时需要使用可滚动游标。
Another approach is to explicitly open the cursor again after ROLLBACK and skip the cursor pointer till the record read at the time of ROLLBACK.
另一种方法是在ROLLBACK之后再次显式地打开游标,然后在ROLLBACK时把游标指针跳到读取的记录。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
应用推荐